No data Typing an equals = in a field will find all records with that field empty.
X Y Z Putting an X into just one of these does the same as clicking on their titles in the LIST display.
However, by putting an X into 2 or 3 of these boxes search for contacts that have an X in
more than one check box.
Date Used to search for documents by their creation date.
Click on one of the buttons which will LIST all documents created in the specified period.
Enter a custoC
m date or date range in the DATE box.
For a date range type two dates with ... in-between (no spaces) e.g. 1/1/95...12/1/96
will display all document created on 1/1/96 to 12/1/96
A>CANCEL Cancels the search returning you to the contacts LIST
Searching
Lists Select details from the pop up menus and lists if required.
Entering details in more than one field allows to you be quite specific in your search criteria.
Part names (Applicable to any box)
Typing a single letter such as A will find all contacts with A as the first letter in that particular field
Insert * (shift 8) to search part names
e.g. *can * will find records that contain: alcan, Canada, cannot, cannery, Tuscany etc.
in that particular fi
Document search
Menu buttons
4Bg/-
Jargon
Alert
u be quite spe
your search
AWA FIELD is the term used in databases to describe the boxes into which you type data.
END OF HELP PAGE
Clicking on these TABS swaps the document details to the selected layout.
Details already typed in will not be lost although when swapping from a longer document to a shorter one
only the text that fits into the page design will be shown. Text that extends off the bottom of the page is
retained but cannot be displayed.
This text can be seen again when swapping to a page layout long enough to accommodate it.
+All document page layouts are able to be customised to suit you companies
stationary.
The design and adjustments of these page layouts should only be undertaken if:
You are familiar with designing page layouts as described in the File maker Pro User Manual.
You have backed up the FADS software.
Notes on designing page layouts
To design page layouts
LETTER LAYOUTS
When you create a new letter/quote/invoice etc... the date is automatically entered into the date field, and
the contact into contact field etc.. If there are spaces in the address because you do not a have job title, do not move the data around in these fields as when you go to search for your letter it will not be searching for a company or contact but the 1st address line.
When you print the document the computer compensates for the spaces.
etup tab names
Clicking on these TABS swaps the document details to the selected layout.
Details already typed in will not be lost although when swapping from a longer document to a shorter one
only the text that fits into the page design will be shown. Text that extends off the bottom of the page is
retained but cannot be displayed.
This text can be seen again when swapping to a page layout long enough to accommodate it.
Menu buttons
QCONTACTS Go to Contacts database and show the current contact
s details
COMPANIES Go to company database and show the current company
s details
LIST Displays documents in the compact list format
DETAIL Displays listed documents with greater detail
SEARCH Search for specified documents
SHOW ALL Displays all documents in database
e and show the current contact
s details
COMPANIES Go to company database and show the current company
s details
LIST Displays documents in the compact list format
DETAIL Displays listed documents with greater detail
SEARCH Search for specified documents
SHOW ALL Displays all documents in database
d documents with greater detail
SEARCH Search for specified documents
SHOW ALL Displays all documents in database
Custom1n
Custom2 exto
Custom3p
Custom4q
Custom 5 ext.r
Custom 6
--tters List
Search
Basic-Letter
Letters List-Detailed
@6A Basic ext
A Basic 5pg
@FA Basic 8pg
Old Style
Old Style ext
HELP-document list
HELP- document search
HELP- document display
Setup letter names
Letters ListB
CompanyTelephoneNo.B
CompanyFAXNo.B
Contacts CHECKBOX XB
ContactNumberB
ContactCalculatedAddressB
LetterTextB
A LetterRefB
LetterDateofCreationB
LetterTypeB
Letter HistoryB
Layout NumberB
Company NumberB
Record positionB
) & " of " &
of
Letter RE::
Working on a copy of the FADS database relating to the documents you wish to adjust,
(for instance, the letters database is called
LETTERS-FADS
Put File maker into LAYOUT mode.
Make the necessary adjustments.
when you have completed put the data base back into BROWSE mode and test you design.
PLEASE NOTE THE FOLLOWING
Allow for non-printing areas on multi-page documents.
You may remove from the document layout any field that is not required, but attempting to make adjus
>tments to
data field definitions may cause serious damage to the database and will surely affect the operation of the
programming of FADS.
To rename the TABS used to swap document formats, click this button.
You are also able to paste in a scanned image that will then print out at the top of your letters.
Navigation Buttons
Go to first record in list
Go to previous record in list
UserB
Master
Helvetica
Geneva
Swis721Ex LT
Times
Swis721 LTi
Swis721 HVi
Swis721 MDi
CONTACTFIRSTNAME
CONTACTJOBTITLE
CONTACTNUMBER
CONTACTS CHECKBOX X
CONTACTS CHECKBOX Y
CONTACTS CHECKBOX Z
CONTACTSALUTATION
CONTACTSURNAME
CONTACTTITLE
CORPORATE ID SCAN
@DOC LAYOUT 1
DOC LAYOUT 2
DOC LAYOUT 3
DOC LAYOUT 4
DOC LAYOUT 5
DOC LAYOUT 6
INVOICE DATE
INVOICE NETT
INVOICE NUMBER
INVOICE PAYMENT TERMS
INVOICE TOTAL
INVOICE VALUE
INVOICE VAT
LAYOUT NUMBER
LETTER HISTORY
LETTER RE:
LETTERDATEOFCREATION
LETTERREF
LETTERTEXT
LETTERTYPE
OUR REFERENCE
RECORD POSITION
SIGNING OFF TEXT
VAT RATE
YOUR REFERENCE
o}Nx!
o}Nx!
HELP- document displayB
Document search
Menu buttons
ffffff
ffff33
ff33ff
ff3333
+U*U+UU
33ffff
33ff33
3333ff
333333
""""""
DDDDDD
UUUUUU
wwwwww
ffffff
ffff33
ff33ff
ff3333
Go to next record in list
Go to last record in list
12 of 35
XThis display shows current document number of total number of documents in current list
AIMPORTANT
These buttons are provided as you should NOT use the Filemaker navigation buttons (on the top left of the screen).
Using the Filemaker buttons will display document details in the current layout, using the FADS buttons will automatically select the correct page layout for any particular document you scroll to.
333333
wwwwww
UUUUUU
DDDDDD
""""""
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
Menu buttons
CONTACTS Go to Contacts database and show the current contact
s details
COMPANIES Go to company database and show the current company
s details
PRINT Print the current document. Make sure the CURRENT RECORD option is selected
NEW Create a new document using the current contact
s details
LIST Show documents in list format
DELETE Permanently deletes the current document from the database
rent document from the database
FaliA
RPTH@
FaliA
RPTH@
LIST@
Contacts CHECKBOX YB
Contacts CHECKBOX ZB
DOC layout 1B
DOC layout 2B
DOC layout 3B
DOC layout 4B
DOC layout 5B
DOC layout 6B
Invoice numberB
Our referenceB
Your referenceB
Description textB
Invoice Value B
Invoice NettB
Invoice VAT
CompanyTelephoneNo.B
CompanyFAXNo.B
Contacts CHECKBOX XB
ContactNumberB
ContactCalculatedAddressB
LetterTextB
A LetterRefB
LetterDateofCreationB
LetterTypeB
Letter HistoryB
Layout NumberB
Company NumberB
Record positionB
) & " of " &
of
Letter RE:
N^ _PON
A#TEXT DOES NOT PRINT BELOW THIS LINE
Letters List-DetailedB
toria Road
he required angle of the backboards.
I am enclosing an elevation detailing the proposed position of the sculptures.
Should you have any queries please do not hesitate to contact me.
Further to our site meeting regarding the above please note the following:
Lighting
20 watt low voltage fittings will be required for the tracks in the main window and the College Road window. Maximum of 4 fittings per sculpture, minimum of 2.
The tracks should be positioned as near to the w
indow pane as possible in each case.
Finishes for Backboards
Main entrance window - Trimite BS 381C range, Dark Violet 796
College Street window - Trimite RAL range, Mint Green 6029
Gold Street window - Pink as per internal schedule
Please note, a dummy for the sculptures is currently being produced to enable us to determine the required angle of the backboards.
I am enclosing an elevation detailing the proposed position of the sculptures.
Should you hav
HELP-document listB
ffffff
ffff33
ff33ff
ff3333
ancelP
Surname
Company name
Numberw
Datex
Historyy
Description{'Put the I.D. of the creator in this box
ContactNumber
Company Number
Today
Last 7 Days
Last 30 Days
Customer Ref
Total
Document type
LetterTypeB
Letter HistoryB
Layout NumberB
Company NumberB
Record positionB
) & " of " &
of
Letter RE:
DATE search - LAST 7 days
b-7) & "..." &
DATE search - LAST 30 days
b-30) & "..." &
DELETE letter
Find all Y CHECKED
Find all Z CHECKED
Number
Client ref.
Total
""""""
DDDDDD
UUUUUU
wwwwww
UU*UU
wwwwww
ffffff
UUUUUU
DDDDDD
333333
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
UTdUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwxwwxw
ffffff
ffff33
ff33ff
ff3333
History
elete
pelling
ontacts
ompanies
N^ _PON
N^ _PON
End of Page 1.
Start of Page 2.
Quotes
FaliA
RPTH@
FaliA
RPTH@
LIST@
B%Get Contact details from CONTACTSFADS
'Roussel Uclaf Environmental Health Ltd.M
McIntyre House High SreetN
Berkhamstead
FarrD
Ms. AH
Venson Fleet Management.M
80-88 Collingdon StN
Luton
Berkhamstead
FarrD
Ms. AH
Venson Fleet Management.M
80-88 Collingdon StN
Luton
Venson Fleet Management.M
80-88 Collingdon StN
Luton
FarrD
Ms. AH
Venson Fleet Management.M
80-88 Collingdon StN
Luton
led from LIST
Sort documents by CONTACT NAME
Sort documents by COMPANY NAME
Sort documents by DOCUMENT TYPE
Sort documents by DOCUMENT REF
$"Sort documents by DOCUMENT HISTORY
pelling
ontacts
ompanies
N^ _PON
N^ _PON
A#TEXT DOES NOT PRINT BELOW THIS LINE
CREDIT NOTE
History
elete
CREDIT NOTE
CHECK unCheck all Y's
+ = "N"
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
CHECK unCheck all Z's
, = "N"
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
NON PRINTING AREA
Purchase order
GRPTH
FPTHAGWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:CONTACTS-fads
FaliA
Winston 2
CONTACTS-fads
FMP3FMP3
GWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:CONTACTS-fads
MSPCA
NAMEA
CONTACTS-fads
RPTHA
CONTACTS-fads
alisA
Winston 2
CONTACTS-fads
FMP3FMP3
GWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:CONTACTS-fads
'RPTH
FPTHA'Fat Boy:RT workspace:FADS:CONTACTS-fads
FaliVDEFA(
(LIST
Test C
ContactD
DirectorF
Dear Mr. ContactH
A test companyM
Address line 1N
Address line 2 O
Address line 3P
Address line 4Q
Address line 5R
012345 6789123S
012345 123456U
1856W
Mr. T. ContactZ
27/3/97[
Custom1\
RT 12:23:59 pm]
27/3/97
530.39
--------------
k amount now due :
3076.62
Your VAT No: 536487416
Our Bank details:
National Westminster Bank
Market Hill Branch
31 George Street
Luton
Bedfordshire LU1 2AH
Sort code: 60 13 28
Account No: 63958309
Mr V Tomin, Ms GE Davis
& Mr A Chambers T/AS
The Finer Detail
2546.23@
63958309@
george@
george@
63958309@
george@
FaliA
RPTH@
LIST@
Company
History
earch
etail
ontacts
ompanies
how All
Check / uncheck list
Company
History
earch
etail
ontacts
ompanies
how All
Check / uncheck list
RPTHA
CONTACTS-fads
alisA
Winston 2
CONTACTS-fads
FMP3FMP3
GWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:CONTACTS-fads
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Custom1
ctions
te of invoice
impson^
9 7777U
1591W
. J. Simpson^
1591W
. J. Simpson^
Mr. N. Kemp^
ola End
Bargain Books Gondola ( 248 x 700)
Stick of Rock Gondola Oversticker 99p
Shelf Talkers x 3 ( each 230 mm x 77 mm)
311.00
545.00
301.00
396.00
1031.00
o Toddington)
.3) 3383 Gifts from Scotland, 3384 London Gifts
To print 2 gondola ends together, 2 colours both sides
130 copies
2.4) 3388 Pick
Mix Toys, 3389 Kids Corner,
3390 Puzzle Pack
HRPTH
FPTHAHWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:COMPANIES-fads
FaliA
Winston 2
COMPANIES-fads
FMP3FMP3
HWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:COMPANIES-fads
MSPCA
NAMEA
COMPANIES-fads
RPTHA
COMPANIES-fads
alisA
Winston 2
COMPANIES-fads
FMP3FMP3
HWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:COMPANIES-fads
GRPTH
FPTHAGWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:CONTACTS-fads
FMRLA
ct ContactSURName from CONTACT-FADSF)Select ContactFIRSTName from CONTACT-FADSG
Signing off text LIST
FMRLA
ContactListCHECKBOXB$Select Company name from COMPANYFADSC
LetterReferenceListE'Select ContactSURName from CONTACT-FADSF)Select ContactFIRSTName from CONTACT-FADSG
Signing off text LISTH
Special instructions
(LIST
VDEFA(
(LIST
VDEFA(
(LIST
LISTA
Valentine Tomin Creative Director
Tony Chambers Production Manager
Mike Holland Enterprise Director
Vanessa Newton Production Assistant
Gillian Davies Financial Director
VDEFA(
e Holland Enterprise Director
Vanessa Newton Production Assistant
Gillian Davies Financial Director
VDEFA(
Pro 3.0F!
UK English - Spelling
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
ContactFirstNameB
ContactSURNameB
ContactTitleB
ContactJOBTitleB
ContactSalutationB
CompanyNameB
CompanyAddress1B
CompanyAddress2B
CompanyAddress3B
CompanyAddress4B
CompanyAddress5
**+*+*+
+*+*+*
*+*+*+*
FaliA
Winston 2
CONTACTS-fads
FMP3FMP3
GWinston 2:Main Applications:FileMaker Pro 3.0 Folder:FADS:CONTACTS-fads
MSPCA
NAMEA
CONTACTS-fads
History
elete
pelling
ontacts
ompanies
elete
pelling
ontacts
ompanies
33ffff
33ff33
3333ff
333333
""""""
DDDDDD
UUUUUU
wwwwww
Cancel Search
Find all X CHECKED
A&CALLED ON ENTRY TO DATABASE-New Letter
Fill in Letter History / Date
LetterSWAP- 2
A(View document details - called from LIST
Goto CONTACTS-FADS
LetterSWAP- 1
DATE search - TODAY
A/CALLED ON ENTRY TO DATABASE-Find & VIEW Letters
chart
)<>0
Cancel
Sorry, there are no documents for this contact.
Select a document from the document list or
use the Search button to look for a specific
document.
Goto NEXT letter
Goto FIRST letter
Goto PREVIOUS letter
Goto LAST letter
SPELLING checker
DATE search - TODAY
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
UU+U*
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
Sort documents by COMPANY NAME
Sort documents by CONTACT NAME
Sort documents by DOCUMENT TYPE
A"Sort documents by DOCUMENT HISTORY
Sort documents by DOCUMENT DATE
Document SEARCH
1/7/96...1/8/96
)<>0
Cancel
Sorry, could not find document(s).
Please try again.
Sort documents by DOCUMENT REF
Create a NEW LETTER
""""""
DDDDDD
UUUUUU
wwwwww
A VAT rate%
N^ _PON
N^ _PON
DescriptionDescription date
Invoice number
Our refernce
Your refernce
Value
Payment Terms:
Total
&CALLED ON ENTRY TO DATABASE-New Letter
/CALLED ON ENTRY TO DATABASE-Find & VIEW Letters
Create a NEW LETTER
Fill in Letter History / Date
DELETE letter
Goto CONTACTS-FADS
Goto COMPANIES-FADS
Goto FIRST letter
Goto PREVIOUS letter
Goto NEXT letter
Goto LAST letter
LetterSWAP- 1
LetterSWAP- 2
LetterSWAP- 3
LetterSWAP- 4
LetterSWAP- 5
LetterSWAP- 6
"(View document details - called from LIST
Sort documents by CONTACT NAME
Sort documents by COMPANY NAME
Sort documents by DOCUMENT TYPE
* Sort documents by INVOICE NUMBER
Sort documents by DOCUMENT REF
Sort documents by INVOICE TOTAL
Sort documents by YOUR REF.
2"Sort documents by DOCUMENT HISTORY
Sort documents by DOCUMENT DATE
Find all X CHECKED
Find all Y CHECKED
Find all Z CHECKED
CHECK unCheck all X's
CHECK unCheck all Y's
CHECK unCheck all Z's
Document SEARCH
Cancel Search
DATE search - TODAY
DATE search - LAST 7 days
Total
voices
invoice
invoice
statement
:46:04
teresa
2:57:27
teresa
3:10:48
1:59:34
2:00:52
vanessan
11:19:48
vanessan
11:36:32
vanessan
12:05:06
Signing off textB
Contacts CHECKBOX YB
Contacts CHECKBOX ZB
DOC layout 1B
DOC layout 2B
DOC layout 3B
DOC layout 4B
DOC layout 5B
DOC layout 6B
Invoice numberB
Our referenceB
Your referenceB
Description textB
Invoice Value B
Invoice NettB
Invoice VAT
SearchB
ce date
note2B
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
note5B
Quote 2pg B
elete
pelling
ontacts
ompanies
canies
History
elete
pelling
ontacts
ompanies
Sorting Sort this list by clicking on the bold titles. Text is listed alphabetically downwards
X Y Z Use these check boxes to create custom lists. Each check box operates independently
of the others. Click in a chequebooks to toggle on/off the
To sort the list to view only those contacts that are checked click on the relevant title.
Use the SEARCH button to list contacts with multiple check boxes activated.
Clicking on a document
s details will display that document in B
the appropriate document format
END OF HELP PAGE
HELP- document search
Description
Invoice date
Invoice number
Our refernce
Your refernce
Value
Payment Terms:
Total
note4B
*U+U+U+
U+U+U+
+U*U+UU
DATE search - LAST 30 days
SPELLING checker
LetterSWAP- 3
LetterSWAP- 4
LetterSWAP- 5
LetterSWAP- 5
LetterSWAP- 5
LetterSWAP- 6
33ffff
33ff33
3333ff
333333
""""""
DDDDDD
UUUUUU
wwwwww
note1B
Invoice No.w
Datex
Historyy
Description{'Put the I.D. of the creator in this box
ContactNumber
Company Number
Today
Last 7 Days
Last 30 Days
Invoices
TFD Ref
Customer Ref
Invoice Total
InvoiceB
(;=7*
))*
,;<<9*
%8=:-
/;<<2
0:<=6*
(5==*
)8==6&
1;>4!
""""""
DDDDDD
UUUUUU
wwwwww
*U+U+U+
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
History
Delivery Note
Delivery Note
Delivery Note
Delivery Note
Delivery Note
Delivery Noter
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
8A Sort documents by INVOICE NUMBER
Sort documents by INVOICE TOTAL
Sort documents by YOUR REF.
""""""
DDDDDD
UUUUUU
wwwwww
*4?IS]hr|
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
*U+U+U+
U+U+U+
o{o{8
HELP- document search
The Check / Uncheck List buttons toggle on/off the check mark for all of the records in the current
list. This feature is useful for creating custom selections that would require multiple searches.
Once you have constructed a list of records using search, click a button to put a check next to
each record listed. Using more searches you can build up a sophisticated selection of records,
using either another check box or adding to the existing set of check marks.
The check marks willB
remain in place until they have been turned off for individual records or
the Check / Uncheck List button has been clicked again
Setup document namesB
U+*+*+*+
**+*+*+*+
T rate%
Total
BA VAT rate%
History
elete
pelling
ontacts
ompanies
History
elete
pelling
ontacts
ompanies
ontactsr
ompaniest
History
elete
pelling
N^ _PON
N^ _PON
Number
Our reference
Your refernce
Quantity & Description
Value
Special instructions:
Netterms:
N^ _PON
N^ _PON
Quantity & Description
Number
Our reference
Your reference
Value
History
elete
pelling
ontacts
ompanies
Letters List
Search
note1
Letters List-Detailed
note2
note3
note4
note5
note6
HELP-document list
HELP- document search
HELP- document display
Setup document names
Letters ListB
N^ _PON
N^ _PON
Invoices
[To change these page tab names , select the text in a tab and type in the replacement text
tPaste a scan of your letterhead into the box below if you wish to have it appear on the
documents in this database.
This scan is setup on each page to align as far as possible to the top and left edge of the page.
Add space to the left hand and top edge of your image if you need to position it elsewhere on the page.
LetterSWAP- 6
CHECK unCheck all X's
= "N"
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
[X_fmv~
IEJPW_goy
e47<AHQXajs}
V(*.3:BJS\eoy
$+3<ENXbkv
$.7AKU_js~
*4?IS]hr|
Letters
Letters
N^ _PON
A#TEXT DOES NOT PRINT BELOW THIS LINE
note6B
Quote 10 pgB
History
elete
History
elete
ffffff
ffff33
ff33ff
ff3333
Setting up & using the user-customisable database.
This database is a virtual copy of the Notes database and as such has a variety of template layouts for
you to customise to create documents that can be used in your organisation, such as standard sales letters.
As you find your way around the layouts and fields used, see them for what they are, text, date & numbers fields.
for instance the field called invoice number can just as easily be used for any other type of identifying
ber system.
You can remove the field containing the body text of a document and just replace it with text typed straight onto
the template itself, therby creating a standard letter which needs no maintenance. Fields that are on one layout
may be freely copied to other layouts. The fields at the very bottom of the template should remain in place.
(.txt)